SQL Query Builder

The SQL Query Builder is a plugin, available from the Tools menu. It provides an interactive environment for designing SQL SELECT queries and view result data sets.

The Output options (see below) are a very quick and powerful way of generating HTML tables of complex data queries from a data source.

General Usage

Before you open the SQL Query Builder, make sure a data connection is selected in the Environment sidebar. The window displays all of the tables and views (if available) for the data connection in the treeview at the top left of the window. Double-click on a table or view to insert its name into the editor area. When you select a table or view, its columns (if available) appear in the list next to the treeview. You can double-click on a column in the list to insert it into the editor. The editor provides syntax highlighting of your SQL code.

Editing SQL Statements in a Document

You can use the SQL Query Builder to edit SQL statements contained in your documents. Simply highlight the statement in the Document Source view and run the SQL Query Builder. The selected text will appear in the SQL Query Builder's editor.

Viewing Query Results

Use the Execute SQL command to run the SQL code in the editor and display results in the grid at the bottom of the window.

Toolbar Commands

The Save and Close command places the SQL Query into the current document and closes the window.

The Close command cancels any changes you've made to the SQL query and closes the window.

The Cut operation removes the selected text from the editor and sends it to the Clipboard.

The Copy operation copies the selected text from your editor to the Clipboard.

The Paste operation pastes text from the Clipboard into the editor. If any text is selected, it is replaced.

The Delete operation removes the selected text in the editor.

The Undo operation undos the last piece of editing done in the editor. It will undo typing, cutting or pasting, and drag and drop operations. Multiple levels of undo are supported.

The Redo operation redos the last editing operation undone in the editor. Multiple levels of redo are supported.

The Execute SQL command runs the SQL code in the editor and displays results in the grid at the bottom of the window.

The Output Straight SQL option specifies to output the SQL code exactly as displayed in the editor.

The Output ASP VBScript option specifies that the SQL code should be output as an ASP VBScript routine that places the results of the SQL into an HTML table.

The Output ASP JScript option specifies that the SQL code should be output as an ASP JScript routine that places the results of the SQL into an HTML table.

The Output CFML option specifies that the SQL code should be output as a CFML routine that places the results of the SQL into an HTML table.

The Do Not Add Table/View Names When Adding Columns flag indicates whether to insert table or view names when you double-click on a column in the column list.